package com.example.sxmall.dao.mapper;

import com.example.sxmall.dao.pojo.Sps_sizes;
import org.apache.ibatis.annotations.Mapper;
import org.apache.ibatis.annotations.Param;

import java.util.List;

@Mapper
public interface Sps_sizesMapper {
    /**
     * 查看定制列表
     * @return
     */
    List<Sps_sizes> listSps_sizes();

    /**
     * 根据ID查看定制信息
     * @param spssid
     * @return
     */
    public Sps_sizes findSps_sizesById(@Param("spssid") Integer spssid);

    /**
     * 根据定制ID查找
     * @param sp_sid
     * @return
     */
    public List<Sps_sizes> findSps_sizesBySid(@Param("sp_sid") Integer sp_sid);

    /**
     * 添加
     * @param sps_sizes
     * @return
     */
    public int insertSps_sizes(@Param("sps_sizes") Sps_sizes sps_sizes);

    /**
     * 删除
     * @param spssid
     * @return
     */
    public int deleteSps_sizes(@Param("spssid") int spssid);

    /**
     * 动态修改
     * @param sps_sizes
     * @return
     */
    public int updateSps_sizes(@Param("sps_sizes") Sps_sizes sps_sizes);
}
